{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CN","Remark"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CN","index":0,"n_rows":5,"n_cols":26,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,0,4,0],[0,9,1,9],[0,10,1,10],[4,8,4,12],[0,8,1,8],[2,8,2,12],[0,11,1,11],[0,6,1,6],[0,12,1,12]]}
["预定交易日期\n(Ex:20170630)",null,"付款人统编\n(CN+7码)",null,"付款人账号",null," 收款人名称","收款银行代码","收款人是否通知\n0:不通知；     1:e-mail","收款人E-Mail Address\n","收款人附言(备注)","发票   笔数\n","销账编号",{"$f":"IF(AH1=2,AH1,IF(AH1=1,AH1,IF(AH1=0,\"\")))","v":""},{"$f":"IF(N1=2,AP1,IF(N1=1,AI1,IF(N1=\"\",\"\")))","v":""},{"$f":"IF(N1=2,AU1,IF(N1=1,AJ1,IF(N1=\"\",\"\")))","v":""},{"$f":"IF(N1=2,AT1,IF(N1=1,AK1,IF(N1=\"\",\"\")))","v":""},{"$f":"IF(N1=2,AQ1,IF(N1=1,AL1,IF(N1=\"\",\"\")))","v":""},{"$f":"IF(N1=2,AR1,IF(N1=1,AN1,IF(N1=\"\",\"\")))","v":""},{"$f":"IF(N1=2,AS1,IF(N1=1,AO1,IF(N1=\"\",\"\")))","v":""},{"$f":"IF(N1=2,AV1,IF(N1<>2,\"\"))","v":""},{"$f":"IF(N1=2,AW1,IF(N1<>2,\"\"))","v":""},{"$f":"IF(N1=2,AX1,IF(N1<>2,\"\"))","v":""},{"$f":"IF(N1=2,AZ1,IF(N1<>2,\"\"))","v":""},{"$f":"IF(N1=2,AY1,IF(N1<>2,\"\"))","v":""}]
["                                                                                                                                                                                                                            付款指示字段→\n(必须输入)","识别代码\n2:付款指示","付款总金额\n(人民币)","對公司付款用途\n(1.货款 2.采购款 3.借款 4.拨款 5.还款 6.上交款 7.旅差费 8.运费 9.保证金 10.其他)\n點我看對個人","收款人身分别\n1:个人\n2:公司","收款人账号",null,"须输入CNAPS的12位收款行代码",null,null,null,null,null,{"$f":"IF(AH2=2,AH2,IF(AH2=1,AH2,IF(AH2=0,\"\")))","v":""},{"$f":"IF(N2=2,AP2,IF(N2=1,AI2,IF(N2=\"\",\"\")))","v":""},{"$f":"IF(N2=2,AU2,IF(N2=1,AJ2,IF(N2=\"\",\"\")))","v":""},{"$f":"IF(N2=2,BA2,IF(N2=1,AK2,IF(N2=\"\",\"\")))","v":""},{"$f":"IF(N2=2,AT2,IF(N2=1,AL2,IF(N2=\"\",\"\")))","v":""},{"$f":"IF(N2=2,AQ2,IF(N2=1,AN2,IF(N2=\"\",\"\")))","v":""},{"$f":"IF(N2=2,AR2,IF(N2=1,AO2,IF(N2=\"\",\"\")))","v":""},{"$f":"IF(N2=2,AS2,IF(N2<>2,\"\"))","v":""},{"$f":"IF(N2=2,AV2,IF(N2<>2,\"\"))","v":""},{"$f":"IF(N2=2,AW2,IF(N2<>2,\"\"))","v":""},{"$f":"IF(N2=2,AX2,IF(N2<>2,\"\"))","v":""},{"$f":"IF(N2=2,AZ2,IF(N2<>2,\"\"))","v":""},{"$f":"IF(N2=2,AY2,IF(N2<>2,\"\"))","v":""}]
["付款明细字段→\n(若无明细,可不输入)","1:付款明细","买售商统编","销售商统编","单据日期","单据号码","付款金额","备注"]
["请从[B6]输入,完成请按上方藍色钮","2","10.11","1","1",20160801890,"Strange ","102100024141","1","smart@msa.hinet.net","apple tart","0","AK488"]
[null,"1",201608018,"88888888","20160510",20160801,"100.23",100.99]

{"sheet":"Remark","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,1],[12,0,12,1],[0,3,0,4]]}
["匯款用途-公司",null,null,"匯款用途-個人"]
["分類編號(Num)","項 目(Item)",null,"分類編號(Num)","項 目(Item)"]
[1,"貨款",null,"A","工資、獎金收入。"]
[2,"採購款",null,"B","稿費、演出費等勞務收入。"]
[3," 借款",null,"C","債券、期貨、信託等投資的本金和收益。"]
[4," 撥款",null,"D","個人債權或產權轉讓收益。"]
[5," 還款",null,"E","個人貸款轉存。"]
[6,"上交款",null,"F","證券交易結算資金和期貨交易保證金。"]
[7,"旅差費",null,"G","繼承、贈與款項。"]
[8,"運費",null,"H","保險理賠、保費退還等款項。"]
[9,"保證金",null,"I","納稅退還。"]
[10,"其他",null,"J","農、副、礦產品銷售收入。"]
[null,null,null,"K","其他合法款項。"]